package com.example.springboot_demo01.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.springboot_demo01.entity.Classes;
import com.example.springboot_demo01.entity.Score;
import com.example.springboot_demo01.entity.Classes;
import com.example.springboot_demo01.entity.Score;

import java.util.List;
import java.util.Map;

public interface ScoreDao extends BaseMapper<Score>
{
    public List<Score> getScoreListByClassAndCourse(int classId,
                                                    int courseId);

    //获得 最高分，最低分，平均分，最大分差
    Map  getMaxAndMinByClassAndCourse(int classId,int courseId);

    //2.获得及格率
    Map  getPassRateByClassAndCourse(int classId,int courseId);


    //3.获得某个课程 成绩中包含的班级信息
    List<Classes>  getClassesList(int courseId);


}
